microsoft excel q/a Practice Questions Answers Test with Solutions & More Shortcuts

Question : 21

In Excel you can print

a) A range of cells by range name

b) An entire worksheet

c) A single worksheet

d) All of the above

Question : 22

In Excel how do you delete a column?

a) Select the column heading you want to delete and select the Delete Row button on the standard toolbar

b) Select the column heading you want to delete and select Insert Delete from the menu

c) Select the row heading you want to delete and select Edit>Delete from the menu

d) Right click the column heading you want to delete and select delete from the shortcut menu

Question : 23

Comments can be added to cells using

a) Edit > Comments

b) Insert > Comments

c) File > Comments

d) View > Comments

e) None of these

Question : 24

If you need to remove only the formatting done in a range (numbers and formula typed there should not be removed), you must

a) From Edit menu choose Clear and then Formats

b) From Edit menu choose Delete

c) Click on Remove Formatting tool on Standard Toolbar

d) Double click the Format Painter and then press Esc key in keyboard

e) None of these

Question : 25

In Excel which of these will not select all the cells in a document?

a) Clicking three times with the right mouse button in the spreadsheet

b) Using the Edit – Select All menu

c) Pressing Ctrl + A on the keyboard

d) Pressing Ctrl + A on the keyboard